How to: Convert text so first letter is capitalized and the rest is lowercase.
Solution:
NOTE: Access does not support a code for this request. However, it is possible to convert text to all uppercase or all lowercase.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) To convert text, do the following:
a) Click on the desired control to convert. (Handles appear around the control.)
b) Select the 'View' menu and select 'Properties'.
c) Click the 'Format' tab.
d) Click on the 'Format' box.
e) To convert text to all uppercase, type the following:
>
f) To convert text to all lowercase, type the following:
<
6) Select the 'File' menu and select 'Save' to save the form.